﻿using CRMFramework;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace CRMBiz
{
    public static class EmailVerificationHandler
    {
        public static DataSet getClientListVerifyEmail(string from, string to)
        {
            DataSet ds;
            try
            {
                ds = new DataSet();
                var para = new[] {
                    DBhelper.SetParameter("@from", from),
                    DBhelper.SetParameter("@to", to)
                };
                ds = DBhelper.ExecuteDataset("select contactid,email,secondEmailAddress,validate_email1,validate_email2 from crm_contact where contactid BETWEEN @from AND @to;", para);

            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ds;
        }
    }
}
